4 つのテーブルを JOIN した VIEW
0001: /************************************************************/ 0002: /* VIEW : VJOIN_SGFO */ 0003: /* */ 0004: /* テーブル SPECIES, GENUS, FANILY, ORDERTAB */ 0005: /* を JOIN して読み取るための VIEW */ 0006: /* */ 0007: /************************************************************/ 0008: CREATE VIEW VJOIN_SGFO( 0009: OSEQNO, 0010: ORDERNAME, 0011: ORDERJPN, 0012: FSEQNO, 0013: FAMILYNAME, 0014: FAMILYJPN, 0015: GSEQNO, 0016: GENUSNAME, 0017: GENUSJPN, 0018: SSEQNO, 0019: SPECIESNAME, 0020: SPECIESJPN, 0021: SPECIESENG, 0022: SPECIESENGCAP 0023: ) 0024: AS 0025: SELECT 0026: ORDERTAB.SEQNO, 0027: ORDERTAB.ORDERNAME, 0028: ORDERTAB.ORDERJPN, 0029: FAMILY.SEQNO, 0030: FAMILY.FAMILYNAME, 0031: FAMILY.FAMILYJPN, 0032: GENUS.SEQNO, 0033: GENUS.GENUSNAME, 0034: GENUS.GENUSJPN, 0035: SPECIES.SEQNO, 0036: SPECIES.SPECIESNAME, 0037: SPECIES.SPECIESJPN, 0038: SPECIES.SPECIESENG, 0039: SPECIES.SPECIESENGCAP 0040: FROM 0041: ORDERTAB, 0042: FAMILY, 0043: GENUS, 0044: SPECIES 0045: WHERE 0046: GENUS.GENUSNAME=SPECIES.GENUSNAME AND 0047: FAMILY.FAMILYNAME=GENUS.FAMILYNAME AND 0048: ORDERTAB.ORDERNAME=FAMILY.ORDERNAME;
この HTML を検査する。( XHTML 1.0 Strict で書かれています )
Another HTML Lint Gateway ( Mirrored by htmllint.oosato.org )