Dear Sir/madam

Please Advise

There is a table for addbook
name
PADD1
PADD2
PCITY
PSTATE
TADD1
TADD2
TCITY
TSTATE
group

Option for Temporary Address & Permanent address
In printout We print all or by state. If state in there in permanent add
or temporary add it should be printed out.

eg. address1 address1
address2 address2
city city
Pstate tstate

But if both address are same then only one of them should be printed out.
If one is blank the obviusly other should be printed out.


I tried SQL with union but I didn't get the req result