selecting records from two tables

[Hamayun Khan]

Hi
I want to retrieve records from two tables such that if table1 has two records and table2 has also two records. then my query return 4 records. The table field names are same but hold different type data
Any help in this issue
Thanks

[r035198x]

Use UNION in the sql.

[Hamayun Khan]

Use UNION in the sql.

Ok Thanks for reply.
I have used it and I get an error.
I will Post latter.