Jump to content

Archived

This topic is now archived and is closed to further replies.

Mr. Marcus

joining

Recommended Posts

I got a db that presents a dvd shop.
what query do i need if i want to display every copy of the dvd's that the shop owns in the querybrowser.
so i have a table DVD and a table COPIES.
i think i will need a join but thats all i know. :-\

thx anyway,
marcus

Share this post


Link to post
Share on other sites
by the way...why dont you just have a table called dvds with fields named 'TITLE' and 'COPIES' then you could just call the results as one table select like: "SELECT title, copies FROM DVDS WHERE 1

Share this post


Link to post
Share on other sites
[quote author=a2bardeals link=topic=111697.msg452888#msg452888 date=1161043811]
SELECT * FROM `DVD`,`COPIES` WHERE 1
[/quote]
Never, ever, run a query like this... post your table structure, and I'll give you an example of a proper query.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.