MySQL Forums
Forum List  »  Newbie

Re: Why use JOINS when have FK
Posted by: Andy Deans
Date: March 24, 2010 04:35PM

thanks chad, i am not too sure what the c or i1 etc means. sorry if that seems dumb.

i tried to use what you given me and use in my tables but did not work.

i tried this so far:

SELECT clients*,
(clients_ClientID is not null) product1,
(clients_ClientID is not null) product2,
(clients_ClientID is not null) product3,
(clients_ClientID is not null) product4,
(clients_ClientID is not null) product5,
(clients_ClientID is not null) product6,
FROM Clients
LEFT JOIN product1.clients_ClientID
ON clients.ClientID = clients.ClientId

can you help please?? :)

thanks

Options: ReplyQuote


Subject
Written By
Posted
March 23, 2010 05:11AM
Re: Why use JOINS when have FK
March 24, 2010 04:35PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.