General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2008 Server
I found the function is COALESCE. But I still only get 66 records not 70.
My situation is this.
I have a table that has 70 item definitions in it (myDefTable).
I have a table that stores records of Assy Index Numbers, item definitions, status, comments (myItemStatusTable).
I want to create a list(cursor) that shows all of the item definitions and where records match to show the status and comments values for a particular Assy Index Number.
I hope this makes sense.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only