Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Copps
  • Order by date
  1. Copps

    MySQL data type matching / composite key / index name

    I have a problem that has raised a couple of questions. SITUATION: I have a table called pr_persona that has a composite key comprising pr_persona_db CHAR(2) pr_persona_id INT(11) auto increment On a separate table, rv_reservation, I have a foreign key that links to pr_persona as follows...
    • Copps
    • Thread
    • Replies: 1
    • Forum: MySQL
  2. Copps

    MySQL Joins

    You can have multiple joins. The following code works. SELECT rf_currency.rf_currency_name FROM ((rf_currency INNER JOIN ac_accomm_rate ON rf_currency.rf_currency_id = ac_accomm_rate.rf_currency_id) INNER JOIN rf_tax_rate ON rf_tax_rate.rf_tax_rate_id = ac_accomm_rate.rf_tax_rate_id) WHERE...

Part and Inventory Search

Back
Top