Create dynamic column

[loveccb]

Hi all,

I have a statement:

SELECT aff_code, aff_name, pw FROM affiliates WHERE aff_code = 'snow'
UNION ALL

SELECT aff_code, aff_name, pw FROM associates WHERE aff_code = 'snow'

But I want to know based on my query which table each row came from(associates or affiliates). Can I create a dynamic column or something? Thanks!

 

[PHV]

SELECT 'affiliates' tblOrig, aff_code, aff_name, pw FROM affiliates WHERE aff_code = 'snow'
UNION SELECT 'associates', aff_code, aff_name, pw FROM associates WHERE aff_code = 'snow'


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[loveccb]

Good lord, thank you PH. I was pulling my hair out on this one.