wizy
Posts: 40
|
| Posted: 06/02/2006, 6:43 PM |
|
Using the sample SQL, how do you build the inner join?
Example in the users SQL, the field is state_id
How do you build the Inner join between the users table state_id to the states table state_id so that the grid being built for Users show the state name instead of a number?
|
 |
 |
wizy
Posts: 40
|
| Posted: 06/02/2006, 6:46 PM |
|
And how do you edit or get the "build query" window back once the grid is created on your design? I dont see a way to rebuild the query once its already placed
|
|
|
|
Benjamin Krajmalnik
|
| Posted: 06/02/2006, 11:07 PM |
|
Wizy,
To get back to the Query Builder, click on the ellipsis on the grids
datasource.
"wizy" <wizy@forum.codecharge> wrote in message
news:24480e9e43b59a@news.codecharge.com...
> And how do you edit or get the "build query" window back once the grid is
> created on your design? I dont see a way to rebuild the query once its
> already
> placed
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
wizy
Posts: 40
|
| Posted: 06/05/2006, 2:22 AM |
|
How do you build the join so that state_id in another table, will call teh state_name from the states table?
|
|
|
|
peterr
Posts: 5971
|
| Posted: 06/05/2006, 10:33 AM |
|
In VQB you drag the "state_id" field from one table to another. This will create a line between them representing a join. You can also specify join direction by right-clicking on that line.
Also see: http://docs.codecharge.com/studio3/html/QuickStart/Crea...citRelship.html
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
