这条select怎么写呀？？？？高手请进。。

Question

select
    *
from 
    daoye0 a, daoye1 b
where
    a.title-id=b.title-id 
    and
    a.price=b.price

Answer 1

select a.*,b.* from daoye0 a,daoye0 b
where a.price=b.price

Answer 2

select * from [daoye0].[dbo].[liu] a ,[daoye1].[dbo].[liu] b  wherea.price=b.price

Answer 3

select * from [daoye0].[dbo].[liu] a ,[daoye1].[dbo].[liu] b  where a.price=b.price

Answer 4

select * from [daoye0].[dbo].[liu] a ,[daoye1].[dbo].[liu] b  wherea.price=b.price
这个是对的,其他的,几个是错误的...我实践过..