How do I get at this fieldname?

[Tony Van]

I have this SQL statement in my VB code...
mySQL = "SELECT * FROM workord" & _
" INNER JOIN customer ON workord.cust_num =
customer.cust_num" & _
" WHERE workord.inv_num = '" & sInvNum & "'"

rs.Open mySQL, myConnection, adOpenDynamic,
adLockOptimistic, adCmdText

Basically doing an Inner Join on workord and customer via an
invoice number field common
to both.

Problem is,both workord and customer have a field named
"flag".
Is there any way to access one (or the other) with ADO?

Thanks for any help.

[Max Healey]

MySQL will return the fields any ambigous fields with their table name dot
field name so the following should work

debug.print rs.fields("workord.flag")
debug.print rs.fields("customer.flag")

or you could define the fields in your query

eg "SELECT customer.flag AS CustomerFLAG, workord.flag AS workordFLAG " & _
" INNER JOIN customer ON workord.cust_num =
customer.cust_num" & _
" WHERE workord.inv_num = '" & sInvNum & "'"

"Tony Van" <to*********@comcast.net> wrote in message
news:ud********************@comcast.com...

I have this SQL statement in my VB code...
mySQL = "SELECT * FROM workord" & _
" INNER JOIN customer ON workord.cust_num = customer.cust_num" & _
" WHERE workord.inv_num = '" & sInvNum & "'"

rs.Open mySQL, myConnection, adOpenDynamic, adLockOptimistic, adCmdText

Basically doing an Inner Join on workord and customer via an invoice
number field common
to both.

Problem is,both workord and customer have a field named "flag".
Is there any way to access one (or the other) with ADO?

Thanks for any help.

[Tony Van]

Worked perfectly!