| Subject | Re: [firebird-support] SQL Help |
|---|---|
| Author | Alexandre Benson Smith |
| Post date | 2007-10-17T01:52:38Z |
Robert martin wrote:
But you could create a view to mimic a summary table, or even create a
table with details with another name, and create a view with the old
name of the table with just a sumary, you will have not to change a lot
of SQL.
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br
> Thanks Helen and AdamI am not sure if I understood it well...
>
> If I wanted to join my Stored procedure in some cases I thought I could
> use the following style join...
>
> JOIN pr_StockLevelByRegion(OtherTable.ItemRef, :RegionRef) ON 1 = 1
>
> Rob Martin
> Software Engineer
>
> phone +64 03 377 0495
> fax +64 03 377 0496
> web www.chreos.com
>
> Wild Software Ltd
>
But you could create a view to mimic a summary table, or even create a
table with details with another name, and create a view with the old
name of the table with just a sumary, you will have not to change a lot
of SQL.
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br