SQL in Visio 2003

[adidasink]

I am curious to know if one could write a sql statement and embed it into a Visio drawing?

For example. I want to view inventory that is only active. Currently when I link the database to the drawing it displays all of the inventory, active or inactive. All I want to do is write a simple sql statement that goes something like this:

Select * from dbo.inventory
where status = "active"

I am unable to find where (if possible) I can limit my results by writing a sql statement.

Help!

 

[Windy77]

I have no experience of this since I am trawling this forum trying to create a Visio drawing of a group of SQL tables, but my first thought is can you not create a View in SQL that selects only "active" inventory and then link that to Visio instead of the table ? Just a thought.