MVSFORUMS.com

[radkrish]

can anyone let me know the query to fetch the fields as per the below.

Condition:
For m_num in table A,I need to fetch the fields m_num, q_num, name, q_num-name,date,week as shown in expected result.

Iam not sure how to add another column and correlate the data correspondingly.
Can anyone help me.

Table A
-------

[Bithead]

Try this:

[radkrish]

Thanks!.The query extracts data in an efficient way.

One more requirement to add to it.I have to combine another table which is l_table_b (late table-similar to table_b.The difference being the data loads into l_table_b in a week and where as data loads in table_b in daily basis)

Both table_b and l_table_b is similar in structure.Except the data stored in it is different.

I thought of using OR condition in where clause to the above.
the query looks like

[radkrish]

I guess that it can also be used with UNION ALL.But
is there any other possible/better way to acheive it.

[Bithead]

I would run a UNION:

[radkrish]

Thanks Bithead