Re: Re: Problems with INNER JOIN
| From: | Chris | Date: | Thu, 29 Jan 2009 23:27:24 +0000 |
| Subject: | Re: Re: Problems with INNER JOIN | ||
| References: | 1 2 3 4 5 6 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-45919@lists.php.net to get a copy of this message | ||
Please post under the other replies, it makes it easier to follow.
Terion Miller wrote:
Yep they both work separately ... can't believe I've been stuck on the same thing all day, it seems like an easy thing...From what you've shown us it should work. Maybe post the output of: show create table workorders; show create table admin; to see if we can spot any discrepencies (maybe one has 'AdminID' and one has 'ID' or something). Do you get any errors from mysql when you run the full query with the join? -- Postgresql & php tutorials http://www.designmagick.com/