Data from two tables in one query, no join?
Posted: Thu Jun 14, 2007 4:02 am
query("
SELECT c.id, g.id as Gid
FROM containment c
FROM geezer g
ORDER BY c.`order`, g.`order`");
Then ofcourse loop through them...is it possible without using a join? They aren't joined in anyway possible, but I need to retrieve there dataset in one.
SELECT c.id, g.id as Gid
FROM containment c
FROM geezer g
ORDER BY c.`order`, g.`order`");
Then ofcourse loop through them...is it possible without using a join? They aren't joined in anyway possible, but I need to retrieve there dataset in one.