multiple ID columns in joined statement

[richrock]

Hi,

 

I'm having a noob day and can't suss out what should be a simple problem...

 

SELECT * FROM bid_auctions LEFT JOIN bids ON bids.userid WHERE bids.userid = ".$usrid."

 

Returns information from two tables, which is getting all the info I need.  However, in both tables there is an 'id' row.  I need to get only the id numbers from bid_auctions not bids.

 

How???  I am completely stumped.

 

???

[fenway]

You can't... * isn't psychic.  You'll need to alias one of the id fields.  BTW, you should really name your PK bid_id and user_id... that way, both the PK and FK have the same name, and you won't ever have name collisions.

[richrock]

Sorry for sounding a little dull (this is my first project after all)...

 

What are PK and FK?

 

I get the whole thing about aliases.  Guess this is going to be a long string, as there's quite a lot of info to be extracted from these tables...

 

Thanks

[fenway]

Primary Key and Foriegn Key.

[aschk]

I'll point you to the area of fault:

"...JOIN bids >>> ON bids.userid <<< WHERE..."

 

ON what? bids.userid IS TRUE, = "darth vader", has rare unconditioned tropical disease? I'll leave it for you to figure out

 

p.s. simple tip: join on something

[fenway]

I'll point you to the area of fault:

"...JOIN bids >>> ON bids.userid <<< WHERE..."

 

ON what? bids.userid IS TRUE, = "darth vader", has rare unconditioned tropical disease? I'll leave it for you to figure out

 

p.s. simple tip: join on something

Yeah, that too... but the * issue still applies.