combining outer and inner join

[JazzMaan]

I want to know if possible .. the syntax to achive an outerjoin ... and a inner join.

Can some one give me a sample syntax.

Thanks

So far i have ...

select T.cap [MARKET CAPITAL]
FROM cover c LEFT OUTER JOIN tic t
ON c.t_name = t.name;

i would like to have a inner join ... where
c.t_name = tableB.t_name and tableB.id = tableC.id

 

[PHV]

Something like this ?
select T.cap [MARKET CAPITAL]
FROM cover c LEFT OUTER JOIN tic t
ON c.t_name = t.name
INNER JOIN (tableB INNER JOIN tableC ON tableB.id = tableC.id) ON c.t_name = tableB.t_name;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244