Posted 16 October 2006 - 08:21 PM
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. :-\
Posted 17 October 2006 - 12:14 AM
Posted 17 October 2006 - 03:45 PM
Never, ever, run a query like this... post your table structure, and I'll give you an example of a proper query.
SELECT * FROM `DVD`,`COPIES` WHERE 1
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users