You need to establish a relation between the two tables to complete the join
with something like:
AND G.GID = U.GID
Also, this is not a PHP related question. You should also be directing this
to the MySQL mailing list.
> -----Original Message-----
> Im having problem in getting the the result values in my cross joint
query.
>
> $query=("Select U.Name, U.Title, G.Groups from Users as U, Groups as G
where U.Id='$Id' ");
****************************************************************************
This message is intended for the sole use of the individual and entity to
whom it is addressed, and may contain information that is privileged,
confidential and exempt from disclosure under applicable law. If you are
not the intended addressee, nor authorized to receive for the intended
addressee, you are hereby notified that you may not use, copy, disclose or
distribute to anyone the message or any information contained in the
message. If you have received this message in error, please immediately
advise the sender by reply email and delete the message. Thank you very
much.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
