Pulling from Multiple tables in a database

Hi, no this doesn't do it. I want to get a value from a user using a simple textbox then plug that value into the WHERE clause BEFORE the grid is populated. In other words, Dynamic SQL.

Any idea if/when you would do this (if at all)

I also see issues with using substring and other functions as well as renaming display columns using the tool (results in no data).

No problem making the SQL code. Here's a query that does exactly what I want it to do.

SELECT jos_fastball_schedule.id, description, jos_fastball_team.name, gamedatetime, field
FROM jos_fastball_schedule
INNER JOIN jos_fastball_team ON hometeam = jos_fastball_team.id
INNER JOIN jos_fastball_location ON location = jos_fastball_location.id
INNER JOIN jos_fastball_gametype ON gametype = jos_fastball_gametype.id
ORDER BY gamedatetime DESC

So how the heck do incorporate it in TABLE JX????

Hi,

I take it that creating a view is a one time event. But what if my data changes periodically and I need to update the view accordingly?

Regards,

Jonas

Thank you Tomaz,

Will try it out.

Regards,

Jonas