Re: SQL... other question.

[mikeh@minivend.com]

******    message to minivend-users from mikeh@minivend.com     ******

Quoting G. Tyler Koblasa (gtyler@onestop.net):
> 
> Greetings...
> 
> The dilemma I am encountering now is that minivend looks for specific
> fields inside the products table.  The SQL server currently has a few other
> tables installed, which contain the description, weight, and price... the
> needed content for the products table.
> 
> I do not believe there is a way to create a link from lets say the weight
> field in Products on over to the weight field in Someothertable.  is there ?
> 
> if not.. i believe it would be most practical, as opposed to copying all
> data into this new table, to modify the SELECT query it uses to obtain the
> needed info.
> how might someone accomplish this ?
> 

Hi,

I can tell you why you might not be getting an answer. I for one can't figure
out what you are talking about. 8-)

	[item-field weight] and [item-data products weight] are usually the same

	[item-data othertable weight] is just as valid

	Shipping table can contain   othertable::weight as a field

What do you mean by "link"? Why are you talking about adjusting
SQL queries? What is the *data* you are trying to access? Just go
and get it and put it where it belongs.

-- 
Mike Heins                          http://www.minivend.com/  ___ 
                                    Internet Robotics        |_ _|____
                                    131 Willow Lane, Floor 2  | ||  _ \
It's a little-known fact            Oxford, OH  45056         | || |_) |
that the Y1K problem caused         <mikeh@minivend.com>     |___|  _ <
the Dark Ages. -- unknown           513.523.7621 FAX 7501        |_| \_\
-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list