|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
|
||||
|
||||
|
1). I found this in MySQL doc:
Derived tables (unnamed views) are now supported! example: SELECT t1.a FROM t1, (SELECT * FROM t2) t3 WHERE t1.a=t3.a; Question: Can we do this in FB? 2). How can I simulate the mysql CREATE TABLE table LIKE table in FB? |
|
#2
|
|||
|
|||
|
1) Yes, if you use development branch of Firebird (2.0)
2) In Firebird 1.5 you can write a stored procedure that will do this taking table names as parameters |
![]() |
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Unnamed views |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|