I just have a quick question with connecting to multiple tables, This is the first time I have attempted to code with a database cotaining multiple tables, is there anything special I need to do access the second table within my database or can I still just throw out the column name to connect to the resultset in that table
Chase, The first thing is to make sure you have a condition in your web clause to join the tables. Otherwise, you will get every combination of rows from both tables.
If the column names are all distinct, you can still use the column name as is to get the result. If not, you can use a column number or an "as statement." For example:
you can access both tables the same way, and deal with the data in your app, this is no different than dealing with multiple Java objects, conceptually
or you can use a join statement and have one single ResultSet, thus one object returned yet multiple tables are searched
Well my data tables do have one common column, its set up like this,
my custNum is a column on both tables I have and the second table cannot exsist without a mathcing value in the first table so the CustNum links the two tables togeather and is the primary key for both tables
This one time, at bandcamp, I had relations with a tiny ad.
a bit of art, as a gift, the permaculture playing cards