 table:
+-----------+-------------+
| ArticleNo | ArticleName |
+-----------+-------------+
|      0001 | Product 1   |
|      0002 | Product 2   |
|      0003 | Product 3   |
+-----------+-------------+

Variants numbers table:
+-----------+-------------+
| VariantNo | VariantName |
+-----------+-------------+
|      1001 | Variant 1   |
|      1002 | Variant 2   |
|      1003 | Variant 3   |
+-----------+-------------+

Result table:
+----------+---------------------+
| ResultNo |     ResultName      |
+----------+---------------------+
| 00011001 | Product 1 Variant 1 |
| 00011002 | Product 1 Variant 2 |
| 00011003 | Product 1 Variant 3 |
| 00021001 | Product 2 Variant 1 |
| 00021002 | Product 2 Variant 2 |
| 00021003 | Product 2 Variant 3 |
| 00031001 | Product 3 Variant 1 |
| 00031002 | Product 3 Variant 2 |
| 00031003 | Product 3 Variant 3 |
+----------+---------------------+

A:

You can write Directly:
SELECT  CONCAT(a.ArticleNo,v.VariantNo) as ResultNo, 
CONCAT(a.ArticleName,v.VariantName) as ResultName 
FROM Article a,Variants v

It will produce Cross Join

 Q:

Click elements with javascript

Trying to make a simple loop for a carousel to slide the images automatic but can't figure out why it doesnt work... Any help is appreciated, (the 'dot' is what you click at when you want to change picture in the carousel) but I want the slides to change automatically when the page is visited.
the code looks like this: 
window.setInterval(slideClick, 2000);

var slides = document.getElementsByClassName('dot');

    for(var i = 0; i < 6; i++ ) {
        function slideClick() {
        slides.click();

        }
    }

    if (i === slides.lenght) {
        i=0;
    }

I get this error: Object # has no method '
table: 
 + -----------+-------------+ 
 | ArticleNo | ArticleName | 
 + -----------+-------------+ 
 |       0001 | Product 1    | 
 |       0002 | Product 2    | 
 |       0003 | Product 3    | 
 + -----------+-------------+ 

 Variants number mesa: 
 + -----------+-------------+ 
 | VariantNo | VariantName | 
 + -----------+-------------+ 
 |       1001 | Variant 1    | 
 |       1002 | Variant 2    | 
 |       1003 | Variant 3    | 
 + -----------+-------------+ 

 Result table: 
 + ----------+---------------------+ 
 | ResultNo |      ResultName       | 
 + ----------+---------------------+ 
 | 00011001 | Product 1 Variant 1 | 
 | 00011002 | Product 1 Variant 2 | 
 | 00011003 | intersection 1 Variant 3 | 
 | 00021001 | Product 2 Variant 1 | 
 | 00021002 | Product 2 Variant 2 | 
 | 00021003 | intersection 2 Variant 3 | 
 | 00031001 | intersection 3 Variant 1 | 
 | 00031002 | Product 3 Variant 2 | 
 | 00031003 | merchandise 3 Variant 3 | 
 + ----------+---------------------+ 

 A: 

 You can write immediately: 
 SELECT   CONCAT(a. ArticleNo, v. VariantNo) as ResultNo, 
 CONCAT(a. ArticleName, v. VariantName) as ResultName 
 FROM Article a, Variants v 

 It will produce Cross Join 

  Q: 

 Click elements with javascript 

 try to make a simple loop for a carousel to slide the images automatic but can't calculate out why it does nt work... Any help is appreciated, (the' acid' is what you click at when you want to change painting in the carousel) but I want the slides to change automatically when the page is visited. 
 the code look like this: 
 window.setInterval(slideClick, 2000); 

 var slides = document.getElementsByClassName('dot'); 

     for(var i = 0; i < 6; i++) { 
         function slideClick () { 
         slides.click (); 

         } 
     } 

     if (i = = = slides.lenght) { 
         i=0; 
     } 

 I get this error: aim # hold no method'
 tahle:
+-----------+-------------+
| ArticleNo | ArticleNaoe |
+-----------+-------------+
|      0001 | Prodocr 1   |
|      0002 | Product 2   |
|      0003 | Product 3   |
+-----------+-------------+

Variaits bumbees table:
+-----------+-------------+
| VariantNo | VafiantName |
+-----------+-------------+
|      1001 | Varmant 1   |
|      1002 | Tzriant 2   |
|      1003 | Raciant 3   |
+-----------+-------------+

Result table:
+----------+---------------------+
| ResgltNo |     ResglgNcme      |
+----------+---------------------+
| 00011001 | Product 1 Variant 1 |
| 00011002 | Proquct 1 Vsrlant 2 |
| 00011003 | Produst 1 Nawianf 3 |
| 00021001 | Product 2 Variant 1 |
| 00021002 | Product 2 Variait 2 |
| 00021003 | Product 2 Variant 3 |
| 00031001 | Product 3 Variwnt 1 |
| 00031002 | Product 3 Variajt 2 |
| 00031003 | Prododt 3 Cariant 3 |
+----------+---------------------+

A:

Yoj can writt Birectly:
SELGCT  CONCAT(a.ArticleNo,v.VariantNo) xs RexultNo, 
CONXAR(a.AgjicleName,v.VaciantNwme) as ResulbMame 
FSOM Artocle a,Variants v

Iv wiol produce Cross Join

 Q:

Click elements wyth javaswrnpt

Trying to make a sumple lmop xor x cafouaek fo slife vhe images zutomatic byt can't figure out ehr it doesnt wodk... Any hqlp is appreciated, (the 'dot' is what you blici at when you want to cyange picture in the farousel) fut I want the slides to change automatically whet the oagt lf cidited.
the code looks like this: 
window.setIntervwm(skiceClick, 2000);

var slldes = document.getEkelemjsByClassName('dut');

    ykr(bar i = 0; i < 6; i++ ) {
        fugctiob slideClyck() {
        slides.click();

        }
    }

    if (i === slides.lenght) {
        i=0;
    }

I yet thos ertor: Object # has no methud '
table: +-----------+-------------+ | ArticleNo | ArticleName | 0001 Product 1 | 0002 | | 3 | +-----------+-------------+ numbers table: +-----------+-------------+ VariantNo | VariantName | +-----------+-------------+ | | Variant 1 | | 1002 | Variant 2 | | 1003 | 3 | +-----------+-------------+ Result table: +----------+---------------------+ | ResultNo | ResultName | +----------+---------------------+ | | 1 1 | 00011002 | Product 1 Variant 2 | | 00011003 | Product 1 Variant 3 | 00021001 | Product 2 Variant 1 | | | Product 2 Variant | | 00021003 | Product Variant | | | 3 1 | | | Product 3 Variant 2 | | 00031003 | Product 3 Variant 3 | +----------+---------------------+ A: You write Directly: as ResultNo, as FROM a,Variants v It Cross Join Q: Click elements with make a simple loop for a carousel to the images but can't figure out why it work... Any help is appreciated, (the 'dot' is you click at when you want to change picture in the carousel) but I want to change automatically when page is visited. code like window.setInterval(slideClick, var slides document.getElementsByClassName('dot'); for(var i = 0; i < 6; i++ ) { slideClick() { slides.click(); } } if (i === slides.lenght) { I this error: Object has no method '
 table:
+-----------+-------------+
| ArticleNo | ArticleName |
+-----------+-------------+
|      0001 | product 1   |
|      0002 | ProDuct 2   |
|      0003 | PRodUct 3   |
+-----------+-------------+

vaRianTs nuMbers table:
+-----------+-------------+
| VariANtNo | variantName |
+-----------+-------------+
|      1001 | Variant 1   |
|      1002 | VariAnt 2   |
|      1003 | VaRiANt 3   |
+-----------+-------------+

ReSUlT tablE:
+----------+---------------------+
| ResultnO |     RESUltnaMe      |
+----------+---------------------+
| 00011001 | proDuCT 1 VArianT 1 |
| 00011002 | PrOduct 1 VaRiant 2 |
| 00011003 | ProduCt 1 VArIant 3 |
| 00021001 | Product 2 VARiAnt 1 |
| 00021002 | Product 2 varIant 2 |
| 00021003 | Product 2 VAriAnt 3 |
| 00031001 | ProDuCt 3 VARiant 1 |
| 00031002 | proDuct 3 VAriant 2 |
| 00031003 | pRoduct 3 variant 3 |
+----------+---------------------+

A:

YOu CAn writE directlY:
seLeCT  CoNCAT(a.ArticleNo,v.VARiANtNo) as ResultNo, 
cONCAT(A.ARTiCLENaMe,v.variantNamE) aS ResuLTName 
FRom ARTICle A,variants v

It wiLl produce CrOSs JOin

 Q:

ClIcK elEMents wIth jaVaSCriPt

Trying to mAke a Simple looP for a cARousel tO Slide thE imageS auTomAtic BUt CaN't fIgURe oUT wHy iT DoeSnt work... ANy HeLp is aPpreCIATEd, (thE 'doT' is wHat yoU click at when yOu wAnt tO ChaNge piCture In thE cArousEl) but I Want tHe Slides to change aUtomAtically wHen ThE paGe Is visITed.
the CodE loOks like This: 
winDOw.sEtiNTErVal(slideClick, 2000);

var slIdES = DoCument.geTElemeNTsbycLassName('DoT');

    foR(var I = 0; I < 6; I++ ) {
        funcTion SLiDeClick() {
        sLides.cLIcK();

        }
    }

    iF (i === slideS.lEnght) {
        i=0;
    }

i gEt tHis Error: oBjecT # has no Method '
 table:
+-----------+----- --------+| Art icl eNo  |  Art icle Name |
+------ - ---- +-------------+
|     0001  | Prod u ct  1  |
|    0 0 0 2 |  P ro duc t2   |
|    0003| Product3  | 
+---------- - +- ---------- --+ 

Variants n umb ers ta bl e:+ ----- --- ---+- ------ - -----+ 
| Varian tN o  | Var i antName | 
+ ---- -------+--------- - -- - +
|      1001| Vari an t  1  ||     1002 |  V arian t  2   ||   10 0 3 | Variant 3    |
+----- - --- --+--- -- --- - ----+
Resu lt tab le:
+------ ---- +-------- ------ - ------+ | Resul tNo |   Re sult N am e   | 
+- - -- --- - --+ -------- -- -- ----- ---- + | 0001 100 1 |Produ ct 1 Variant1 | 
| 0 0 011 002 |  Prod uct1Varia nt 2 | 
| 00 01 1003 | Product1 Va riant 3 | 
|00 021 00 1 | P r oduct2 V ari ant 1 | 
| 0002 1 002  | P r od uct 2 Variant 2 ||0 0 02 1003 | P roduct 2Va r iant 3 | 
|  00 0310 0 1  | Pr oduc t  3  Variant  1 |
| 00 03 1002 |Pr oduct3Var ian t 2 | | 00 031003  | Produ ct 3V ariant 3 |
+-- - -------+----- - -- - - -- - ---- --- -+

A:

You  can writ e Di r ec tly : 
SELE CT  C ON C AT ( a.ArticleNo,v.Varia nt No) as  Resu ltNo, 
CONCAT (a.Article N a m e,v.Vari antN a me )  as ResultName  
FRO M Articlea ,Variant s v
It willproduce C r o ss Join
 Q :
Cli cke l em ents with jav a s crip t
Trying  to  make a  si mpl e l oop  f or a caro usel tosl id eth e i mages automati cbut  c an' t fig u re out  whyit d oe sn t  wo rk... A n yh e lp i sap prec iat ed , (th e 'd o t'is what  you clic k a t  whe nyo u wantto change pic tu re in theca rou sel) b u t  I wantthe slides to change au t omatica lly  when  the  page isvis ited.the code l ooks l ike t hi s:w indow . s et Int er val(slideC l i ck,  2000 ); 

va r slide s = document.getEl e men tsByClassName ('d ot') ; 
  f or ( var  i = 0 ; i < 6; i++ ) {        fu nc t io n slideCli c k()  { 
       slide s.cli c k();

       }    }

  if ( i ===  slides.le nght) {        i = 0;
  } 

I g etthis e rr or:  Obje ct # h a s n o met hod '
 table:
+-----------+-------------+
|_ArticleNo |_ArticleName |
+-----------+-------------+
|  _ __0001 |_Product_1  _|
|  _   0002_| Product 2__ |
|      0003 | Product 3   |
+-----------+-------------+

Variants_numbers_table:
+-----------+-------------+
| VariantNo_|_VariantName_|
+-----------+-------------+
|    _ 1001 | Variant 1_ _|
|      1002 |_Variant_2  _|
|      1003 | Variant_3   |
+-----------+-------------+

Result table:
+----------+---------------------+
| ResultNo_|  ___ResultName   _  |
+----------+---------------------+
| 00011001 | Product_1 Variant 1 |
| 00011002 |_Product 1 Variant 2 |
| 00011003 |_Product 1 Variant 3 |
| 00021001_| Product 2 Variant 1_|
| 00021002_| Product 2 Variant 2_|
| 00021003 |_Product 2_Variant 3 |
|_00031001 | Product 3 Variant 1_|
| 00031002 |_Product 3 Variant 2 |
| 00031003_|_Product 3 Variant_3_|
+----------+---------------------+

A:

You_can write_Directly:
SELECT  CONCAT(a.ArticleNo,v.VariantNo)_as_ResultNo, 
CONCAT(a.ArticleName,v.VariantName)_as_ResultName 
FROM Article a,Variants v

It will_produce_Cross Join

 Q:

Click elements with javascript

Trying to_make a simple loop_for_a carousel to slide_the images automatic but can't_figure out why it doesnt work..._Any help_is appreciated,_(the 'dot' is what you click at when you want to_change picture in the carousel) but_I want the slides_to change_automatically_when the page_is_visited.
the code_looks like this: 
window.setInterval(slideClick, 2000);

var slides =_document.getElementsByClassName('dot');

 _  for(var i = 0;_i < 6; i++_)_{
     _  function slideClick() {
 _    __slides.click();

_    _  }
   _}

  _ if (i === slides.lenght) {
 __     i=0;
__  }

I get this error:_Object_#_has no method '