I wonder if anyone would help me out here, I m trying to link tables together to get some information to produce a report. But i m new to sql so need some help completing this asap:
select * from tvdba.mdd_media, tvdba.mdd_containers, tvddba.mdd_media_contnrs_link
where m.media_id = l.media_id (+)
I want to join the query for starters!
So for example, i want to select the following items:
Any ideas how to go about this, would be very helpful, something to start me off.
Thanks in advance
Edited 22-Mar-13 4:04am
Join works basically like this:
SELECT TableA.*, TableB.*, TableC.*, TableD.*
FROM TableA TA
JOIN TableB TB
ON TA.aID = TB.aID
JOIN TableC TC
ON TA.cID = TC.cID
JOIN TableD TD
ON TA.dID = TD.dID
WHERE TA.media_id LIKE ...
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)