EasyCFM.COM ColdFusion Forums / MySQL Related Issues / Join table not quite

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: Join table not quite -- page: 1 2

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

Lossed
08-29-2007 @ 10:41 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Senior Member
Posts: 1095
Joined: Apr 2004

Figured it out yet daveED?
If so, I'm keen to learn how you did it.

Tks

Lossed
---------------------------
When the only tool you have is a hammer, everything looks like a nail Smile
-----------------------------

daveED
08-30-2007 @ 10:57 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Junior Member
Posts: 116
Joined: Sep 2006

Not yet lossed,
But when i do, i will let you know.

daveED
08-31-2007 @ 4:25 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Junior Member
Posts: 116
Joined: Sep 2006

Lossed, i ended up using UNION,
Because the some of the colum names being referenced were not the same i used AS.

SELECT t1.whatever AS myValue,
       t2.somecol  AS myValue

PAGE: 1 2

Website Designed and Developed by Pablo Varando.