Question Locked

Sql QUery needed

0 helpful

2 replies

by sebasmtech Jan 24, 2008 last reply Jan 24, 2008

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I want to take the datas from two different table having same field name for example,

customer_name is the field name

this field is both in
cust_info
cust_act

if i use the UNION Query it asks exactly the same no of fields both in righ and left of UNION

is there any other way to get the datas from both the table?

2 replies

Clarifications

Use only the field name is the sql query instead of using the *, so that both your union queries have equal columns

Regards,
UrStop

This discussion is closed to new replies.