is this call inner join as well ?

hi, if i have query like following

select * from o_customer,o_address
where
o_customer.name = o_address.custname

is it same as

select * from o_customer
inner join o_address on o_customer.name = o_address.custname

if there are same, which one is prefer in term of performance ..

thank you for guidanceHi

Former is old school, latter is current ANSI compliant.

I would imagine the optimiser would be able to equate the two but if it didn't then number one is likely to be a dog compared to the ANSI join

HTH|||BTW - I would use neither:

SELECT Col1, Col2, Col3
FROM o_customer
INNER JOIN o_address ON o_customer.name = o_address.custname
;)