急、急、急、十万火急，InterBase中的Select语句(50分)

X

xiaoliu

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-15

• #1

[]我要在InterBase[中实现SQL Server 的
select * from A1,A2
where A1.Id+=A2
找不到相应的函数，我安装了FreeUDFLIB，这里面有吗，
向这样的的Left、Right的Join 在InterBase如何实现

 

H

huawdg

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-15

• #2

SELECT * FROM A1 LEFT OUTER JOIN A2 ON A1.ID=A2.ID

 

X

xiaoliu

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-15

• #3

谢了，我先试试

 

X

xiaoliu

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-11

• #4

接受答案了.