No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
Here is a sample of my table: ID Name Codes 1 John D S12, S13, S89 1 John D S98, T12 2 Joe D X27, S28 3 Bob S F12, F13, X43 3 Bob S S44, X38, S90 4 Steve F D25 I want a query that will return the …
|
|
|
The issue I am having is the following: Table1.FieldA is unique where as the Table2.FieldA field is not. When I run the following: SELECT Table1.Numbers, Table2.Numbers FROM Table1, Table2 WHERE Table1.ID = Table2.ID I get mutiple records like so: ID Name Numbers 125 John Doe 555, 556, 557 125 John …
|
|
|
I am trying to pull data from a table to fill a drop down list. Now, i got the fill part working, but am having an issue passing a variable value to my form post action. Code: $query ="SELECT UniqueIdentifier, LastName, FirstName FROM BrokerMain ORDER BY LastName"; $result = @mssql_query($query); …
|