Adding AS table.column to LEFT JOIN query

Question

I have 2 tables "data" and "listings" that I'm doing a LEFT join on. Both tables have an ID column. The problem is, I can't figure out how to do AS with a join so I can later reference data.ID and listings.ID in my PHP script. Here's my current query, which results in 2 columns both labeled ID

`SELECT * FROM `listings` LEFT JOIN `data` ON ( `listings`.`REALTOR` = `data`.`ID` ) WHERE `listings`.`ACTIVE` = '1' AND `listings`.`MODIFIED` < NOW( ) - INTERVAL 90 DAY `

juergen d · Accepted Answer · 2016-09-20 15:41:16Z

1

SELECT l.*, d.*,
       l.id as listing_id, 
       d.id as data_id
FROM listings l
LEFT JOIN data d ON l.REALTOR = d.ID
WHERE l.ACTIVE = '1' 
AND l.MODIFIED < NOW() - INTERVAL 90 DAY

answered Sep 20, 2016 at 15:41

juergen d

205k40 gold badges304 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Duane Lortie Over a year ago

Thank you. I was SO CLOSE ! One of my many attempts was id as l.listing_id UGH

Collectives™ on Stack Overflow

Adding AS table.column to LEFT JOIN query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related