|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
September 2nd, 2005, 02:21 AM
|
|||
|
|||
Select across tables
Hi,
I'm migrating code from MSSQL to FB and have a section of code that uses cross table queries like this: (MSSQL) select * from db1.dbo.table1 ... The app fails on FB with table not found. How do I use a 'fully qualified' name in FB? I need to use a couple of tables in the same query as it is compares values from 2 tables. Thanks in advance, Simon
|
|
#2
September 2nd, 2005, 03:06 AM
|
||||
|
||||
|
Quote:
What do you mean? Do they have the same name but are placed in different databases?
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
#3
September 2nd, 2005, 04:09 AM
|
|||
|
|||
|
Quote:
What do you mean by "cross table query"? It is natural thing to do ;-) I do, however, think that you need cross database query, and that is not possible in query. You can try alternative approach, using IBExpert's tools: IBEBLOCK http://www.ibexpert.com/download/ibeblock_docu.txt -- Best regards, Fikret Hasovic http://fikret.fbtalk.net * Firebird Foundation Committee member. - Join today at http://www.firebirdsql.org/ff/foundation * JEDI VCS contributor http://jedivcs.sourceforge.net/ * Firebird and Fyracle news http://www.fyracle.org
|
|
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Select across tables |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
