Splitting a large group of results

[jensies]

Hi,

I have a few tables which I need to join together and get a number of fields out of. Each of these tables have the same first five fields (all with different results). The result I get aget makign the join and running the query is one long list of results with a lot of same field names.

Is there any way I can split up these results into a number of smaller results?

Thanks

Here is a section of my code to let you know what I mean:

select *
from tableA,tableB,tableC
where tableA.docId = tableB.docId AND
tableB.docId = tableC.docId

 

[skuhlman]

select tableA.*,
tableB.FieldX,
tableB.FieldY,
tableB.FieldZ,
tableC.FieldQ
from tableA join tableB
on tableA.docId = tableB.docId
join tableC
on tableB.docId = tableC.docId

 

[jensies]

Hi,

Unfortunately that doesnt help me because I still have only one row of data

But, thanks anyway!

 

[SQLBill]

Can you give us an example of your script, your results, and what results you want to see?

-SQLBill

 

[jensies]

Hi,

I got this sorted using UNION instead, but, thanks for your help!